BI-Naveen - 2017-06-04 - 40658 - Service Request - 8553 - Sales Analysis with Discounts - 8M USD no seasons(MIchael Carducci by 2017-06-19) #wipdoc
Service Request
40658 - Sales Analysis with Discounts(8m USD no seasons)
Problem Summary
Need to check why no proper season is assigned to the salesorder and move it out to valid season if possible
Admin Info
Purpose
|
Need to check why no proper season is assigned to the salesorder and move it out to valid season if possible
|
Requested by
|
Michael Carducci
|
Issue Date
|
06-14-2017
|
Resolved by
|
Naveen Gadde
|
Resolved Date
|
06-19-2017
|
Document Status
|
Complete
|
Detailed Problem Description
Comment in Zendesk by Michael Carducci on 06/15/2017:
Hi, in query Sales Analysis with Discounts [VMP_OPASA_Q007], there is over $8M in negative sales that do not appear to be assigned to a season or a season consolidation. The season is "Objective is to figure out why, and move to proper season or season consolidation if possible. Thanks!
Solution Analysis and Recommendations
The Negative revenue is due to the reason that season is not assigned to those orders even in SAP. We have identified that there are few Sales orders, 1 contract & Higher number of Return orders & debit/credit memo orders which has season not assigned.
Note: For debit memo & Credit memo orders season indicator is not even set in SAP, So for these order season will not be available
Resolution
The credit and debit memos wont have season and collection fields populated and hence those orders will be assigned to "other" in the consolidation while showing in sales analysis queries.This has been explained to user over a meeting and it has been agreed to complete this ticket.
Release Information
None